package com.be.beadmin.material.entity;

import com.be.beadmin.common.entity.BaseEntity;
import lombok.Data;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;
import java.util.Date;

/**
 * @Author: Mengyang Zhu
 * @Date: 2023/5/14 21:54
 * @Description: 分料详情
 */
@Entity
@Data
@Table(name = "T_MM_PickingDetails")
public class
PickingDetails extends BaseEntity {
    @Column(name = "ProjectName", columnDefinition = "VARCHAR(50) COMMENT '项目名称' ")
    private String projectName;
    @Column(name = "PickingTaskCode", columnDefinition = "VARCHAR(50) COMMENT '分料任务号' ")
    private String pickingTaskCode;

    @Column(name = "MaterialSequence", columnDefinition = "VARCHAR(50) COMMENT '物料序号' ")
    private String materialSequence;

    @Column(name = "MaterialCode", columnDefinition = "VARCHAR(50) COMMENT '物料编码' ")
    private String materialCode;

    @Column(name = "PartCode", columnDefinition = "VARCHAR(50) COMMENT '产品编码' ")
    private String partCode;

    @Column(name = "ProductCode", columnDefinition = "VARCHAR(50) COMMENT '柜体编号' ")
    private String productCode;

    @Column(name = "MaterialName", columnDefinition = "VARCHAR(50) COMMENT '物料名称' ")
    private String materialName;

    @Column(name = "ChangeStatus", columnDefinition = "int COMMENT '变更状态' ")

    private int changeStatus;

    @Column(name = "PositionNo", columnDefinition = "VARCHAR(50) COMMENT '位置号' ")
    private String positionNo;

    @Column(name = "Unit", columnDefinition = "VARCHAR(50) COMMENT '单位' ")
    private String unit;

    @Column(name = "MaterialSpec", columnDefinition = "VARCHAR(50) COMMENT '规格' ")
    private String materialSpec;

    @Column(name = "ProcessCode", columnDefinition = "VARCHAR(50) COMMENT '所属工序' ")
    private String processCode;

    @Column(name = "MaterialQty", columnDefinition = "double COMMENT '物料数量' ")
    private double materialQty;

    @Column(name = "NotIssuedQty", columnDefinition = "double COMMENT '未分数量' ")
    private double notIssuedQty;
    @Column(name = "unclaimedQty", columnDefinition = "double COMMENT '未收数量' ")
    private double unclaimedQty;
    @Column(name = "claimedQty", columnDefinition = "double COMMENT '已接收数量' ")
    private double claimedQty;
    @Column(name = "OutboundQty", columnDefinition = "double COMMENT '已分数量' ")
    private double outboundQty;

    @Column(name = "CurrentQty", columnDefinition = "double COMMENT '当前未分数量——固定")
    private double currentQty;

    @Column(name = "ThistimeQty", columnDefinition = "double COMMENT '本数次量' not null default 0")
    private double thistimeQty;

    @Column(name = "IsChanged", columnDefinition = "VARCHAR(1) COMMENT '变更状态' ")
    private String isChanged;
    @Column(name = "SerialNumGroup", columnDefinition = "VARCHAR(50) COMMENT '序列号组' ")
    private String serialNumGroup;
    @Column(name = "SerialNum", columnDefinition = "VARCHAR(50) COMMENT '序列' ")
    private String serialNum;
    @Column(name = "Memo", columnDefinition = "text COMMENT '备注' ")
    private Date memo;
    @Column(name = "Wo", columnDefinition = "VARCHAR(50) COMMENT '工单编号' ")
    private String wo;
    @Column(name = "DeliveryDate", columnDefinition = "datetime COMMENT '到货日期' ")
    private Date DeliveryDate;

    @Column(name = "isJia" , columnDefinition = "VARCHAR(50) COMMENT '是否甲供料' ")
    private String isJia;

    @Column(name = "materialClassification",columnDefinition = "VARCHAR(50) COMMENT '物料分类' ")
    private String materialClassification;
    @Column(name = "materialType",columnDefinition = "VARCHAR(50) COMMENT '物料种类' ")
    private String materialType;

}
